﻿CREATE TABLE [dbo].[Person]
(
	[PersonId] [int] IDENTITY(1,1) NOT NULL, 
	[DomainUserName] [varchar] (50) NOT NULL,
	[FirstName] [varchar] (150) NOT NULL,
    [LastName] [varchar] (150) NOT NULL,
    [Email] [varchar] (250) NULL,
    [DateCreated] [datetime] NOT NULL,
    [CreatedBy] [varchar] (50) NOT NULL,
    [DateUpdated] [datetime] NOT NULL,
    [UpdatedBy] [varchar] (50) NOT NULL,
    CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED 
    (
	    [PersonId] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
) ON [PRIMARY]